{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='马自达')]\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口马自达>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='马自达']\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['brand']=='马自达')|(all1['brand']=='马自达(MAZDA)')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CA7250ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1497</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CA7200ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1447</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CA7250ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1484</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CA7200ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1469</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CA7250ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1497</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CA7250ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1484</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CA7200ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1447</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CA7200ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1469</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CA7200ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1469</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CA7250ATE4</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1484</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CA7250ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1497</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CA7250ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1484</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CA7200ATE4</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1447</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CA7250ABE4</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1497</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CA7200ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1447</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CA7200ABE4</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1469</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CA7200ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1447</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CA7250ATE4</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1484</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CA7250ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1497</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CA7250ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1484</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CA7200ATE4</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1447</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CA7250ABE4</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1497</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CA7200ABE4</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1469</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CA7200ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1469</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870</td>\n",
       "      <td>1840</td>\n",
       "      <td>1450</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4ACP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2830</td>\n",
       "      <td>4870x1840x1450</td>\n",
       "      <td>马自达</td>\n",
       "      <td>阿特兹</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CA7252ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1560</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633</td>\n",
       "      <td>1840</td>\n",
       "      <td>1535</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5CPP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633x1840x1535</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CA7252ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1545</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633</td>\n",
       "      <td>1840</td>\n",
       "      <td>1535</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5CPP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633x1840x1535</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>CA7202MTE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1390</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633</td>\n",
       "      <td>1840</td>\n",
       "      <td>1535</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4APE×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633x1840x1535</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CA7252ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1545</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633</td>\n",
       "      <td>1840</td>\n",
       "      <td>1535</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5CPP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633x1840x1535</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CA7202MTE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1390</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633</td>\n",
       "      <td>1840</td>\n",
       "      <td>1535</td>\n",
       "      <td>1998</td>\n",
       "      <td>116</td>\n",
       "      <td>LFPM4APE×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633x1840x1535</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CA7252ABE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1560</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633</td>\n",
       "      <td>1840</td>\n",
       "      <td>1535</td>\n",
       "      <td>2488</td>\n",
       "      <td>141</td>\n",
       "      <td>LFPM5CPP×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFP</td>\n",
       "      <td>2700</td>\n",
       "      <td>4633x1840x1535</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>CAM6460D5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1560</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCAC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>CAM6460N</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1435</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCMC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>CAM6460F5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1609,1625</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>2488</td>\n",
       "      <td>144</td>\n",
       "      <td>LVRHDCAS×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>CAM6460F5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1609,1625</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>2488</td>\n",
       "      <td>144</td>\n",
       "      <td>LVRHDCAS×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>CAM6460B5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1455</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCAC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>CAM6460N5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1435</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCMC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>CAM6460D5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1560</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCAC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>CAM6460B</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1455</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCAC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>CAM6460F</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1609,1625</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>2488</td>\n",
       "      <td>144</td>\n",
       "      <td>LVRHDCAS×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>CAM6460F5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1609,1625</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>2488</td>\n",
       "      <td>144</td>\n",
       "      <td>LVRHDCAS×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>CAM6460N</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1435</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCMC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>CAM6460B</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1455</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCAC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>CAM6460B5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1455</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCAC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>CAM6460N5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1435</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCMC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>CAM6460D</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1560</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCAC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>CAM6460D5</td>\n",
       "      <td>马自达(MAZDA)</td>\n",
       "      <td>1560</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555</td>\n",
       "      <td>1840</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>114</td>\n",
       "      <td>LVRHDCAC×××××××××</td>\n",
       "      <td>长安马自达汽车有限公司</td>\n",
       "      <td>LVR</td>\n",
       "      <td>2700</td>\n",
       "      <td>4555x1840x1710</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>CA6490AT5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1787</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860</td>\n",
       "      <td>1852</td>\n",
       "      <td>1685</td>\n",
       "      <td>2488</td>\n",
       "      <td>120</td>\n",
       "      <td>LFBME308×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860x1852x1685</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>CA6490AT5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1787</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860</td>\n",
       "      <td>1852</td>\n",
       "      <td>1685</td>\n",
       "      <td>2488</td>\n",
       "      <td>120</td>\n",
       "      <td>LFBME308×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860x1852x1685</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>CA6490AT</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1762</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860</td>\n",
       "      <td>1852</td>\n",
       "      <td>1685</td>\n",
       "      <td>2261</td>\n",
       "      <td>113</td>\n",
       "      <td>LFBME308×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860x1852x1685</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>CA6490AT5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1787</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860</td>\n",
       "      <td>1852</td>\n",
       "      <td>1685</td>\n",
       "      <td>2488</td>\n",
       "      <td>120</td>\n",
       "      <td>LFBME308×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860x1852x1685</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>CA6490AT5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1787</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860</td>\n",
       "      <td>1852</td>\n",
       "      <td>1685</td>\n",
       "      <td>2488</td>\n",
       "      <td>120</td>\n",
       "      <td>LFBME308×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860x1852x1685</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>CA6490AT</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1762</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860</td>\n",
       "      <td>1852</td>\n",
       "      <td>1685</td>\n",
       "      <td>2261</td>\n",
       "      <td>113</td>\n",
       "      <td>LFBME308×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860x1852x1685</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>CA6490AT</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1762</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860</td>\n",
       "      <td>1852</td>\n",
       "      <td>1685</td>\n",
       "      <td>2261</td>\n",
       "      <td>113</td>\n",
       "      <td>LFBME308×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860x1852x1685</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>CA6490AT</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1762</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860</td>\n",
       "      <td>1852</td>\n",
       "      <td>1685</td>\n",
       "      <td>2261</td>\n",
       "      <td>113</td>\n",
       "      <td>LFBME308×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860x1852x1685</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>CA6490AT</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1762</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860</td>\n",
       "      <td>1852</td>\n",
       "      <td>1685</td>\n",
       "      <td>2261</td>\n",
       "      <td>113</td>\n",
       "      <td>LFBME308×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2950</td>\n",
       "      <td>4860x1852x1685</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>CA6473ATE4R</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1806</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705</td>\n",
       "      <td>1872</td>\n",
       "      <td>1645</td>\n",
       "      <td>2261</td>\n",
       "      <td>175</td>\n",
       "      <td>LFBME066×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705x1872x1645</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-7</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>CA6473ATE5</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1618</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705</td>\n",
       "      <td>1872</td>\n",
       "      <td>1645</td>\n",
       "      <td>2488</td>\n",
       "      <td>120</td>\n",
       "      <td>LFBME306×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705x1872x1645</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-7</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>CA6473ATE4R</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1806</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705</td>\n",
       "      <td>1872</td>\n",
       "      <td>1645</td>\n",
       "      <td>2261</td>\n",
       "      <td>175</td>\n",
       "      <td>LFBME066×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705x1872x1645</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-7</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>CA6473ATE4</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1618</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705</td>\n",
       "      <td>1872</td>\n",
       "      <td>1645</td>\n",
       "      <td>2488</td>\n",
       "      <td>120</td>\n",
       "      <td>LFBME306×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705x1872x1645</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-7</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>CA6473ATE4R</td>\n",
       "      <td>马自达</td>\n",
       "      <td>1806</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705</td>\n",
       "      <td>1872</td>\n",
       "      <td>1645</td>\n",
       "      <td>2261</td>\n",
       "      <td>175</td>\n",
       "      <td>LFBME066×××××××××</td>\n",
       "      <td>中国第一汽车集团公司</td>\n",
       "      <td>LFB</td>\n",
       "      <td>2750</td>\n",
       "      <td>4705x1872x1645</td>\n",
       "      <td>马自达</td>\n",
       "      <td>马自达CX-7</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>330 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     notice_type     brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0     CA7250ABE5         马自达        1497      2830       4870      1840   \n",
       "1     CA7200ATE5         马自达        1447      2830       4870      1840   \n",
       "2     CA7250ATE5         马自达        1484      2830       4870      1840   \n",
       "3     CA7200ABE5         马自达        1469      2830       4870      1840   \n",
       "4     CA7250ABE5         马自达        1497      2830       4870      1840   \n",
       "5     CA7250ATE5         马自达        1484      2830       4870      1840   \n",
       "6     CA7200ATE5         马自达        1447      2830       4870      1840   \n",
       "7     CA7200ABE5         马自达        1469      2830       4870      1840   \n",
       "8     CA7200ABE5         马自达        1469      2830       4870      1840   \n",
       "9     CA7250ATE4         马自达        1484      2830       4870      1840   \n",
       "10    CA7250ABE5         马自达        1497      2830       4870      1840   \n",
       "11    CA7250ATE5         马自达        1484      2830       4870      1840   \n",
       "12    CA7200ATE4         马自达        1447      2830       4870      1840   \n",
       "13    CA7250ABE4         马自达        1497      2830       4870      1840   \n",
       "14    CA7200ATE5         马自达        1447      2830       4870      1840   \n",
       "15    CA7200ABE4         马自达        1469      2830       4870      1840   \n",
       "16    CA7200ATE5         马自达        1447      2830       4870      1840   \n",
       "17    CA7250ATE4         马自达        1484      2830       4870      1840   \n",
       "18    CA7250ABE5         马自达        1497      2830       4870      1840   \n",
       "19    CA7250ATE5         马自达        1484      2830       4870      1840   \n",
       "20    CA7200ATE4         马自达        1447      2830       4870      1840   \n",
       "21    CA7250ABE4         马自达        1497      2830       4870      1840   \n",
       "22    CA7200ABE4         马自达        1469      2830       4870      1840   \n",
       "23    CA7200ABE5         马自达        1469      2830       4870      1840   \n",
       "24    CA7252ABE5         马自达        1560      2700       4633      1840   \n",
       "25    CA7252ATE5         马自达        1545      2700       4633      1840   \n",
       "26    CA7202MTE5         马自达        1390      2700       4633      1840   \n",
       "27    CA7252ATE5         马自达        1545      2700       4633      1840   \n",
       "28    CA7202MTE5         马自达        1390      2700       4633      1840   \n",
       "29    CA7252ABE5         马自达        1560      2700       4633      1840   \n",
       "..           ...         ...         ...       ...        ...       ...   \n",
       "300    CAM6460D5  马自达(MAZDA)        1560      2700       4555      1840   \n",
       "301     CAM6460N  马自达(MAZDA)        1435      2700       4555      1840   \n",
       "302    CAM6460F5  马自达(MAZDA)   1609,1625      2700       4555      1840   \n",
       "303    CAM6460F5  马自达(MAZDA)   1609,1625      2700       4555      1840   \n",
       "304    CAM6460B5  马自达(MAZDA)        1455      2700       4555      1840   \n",
       "305    CAM6460N5  马自达(MAZDA)        1435      2700       4555      1840   \n",
       "306    CAM6460D5  马自达(MAZDA)        1560      2700       4555      1840   \n",
       "307     CAM6460B  马自达(MAZDA)        1455      2700       4555      1840   \n",
       "308     CAM6460F  马自达(MAZDA)   1609,1625      2700       4555      1840   \n",
       "309    CAM6460F5  马自达(MAZDA)   1609,1625      2700       4555      1840   \n",
       "310     CAM6460N  马自达(MAZDA)        1435      2700       4555      1840   \n",
       "311     CAM6460B  马自达(MAZDA)        1455      2700       4555      1840   \n",
       "312    CAM6460B5  马自达(MAZDA)        1455      2700       4555      1840   \n",
       "313    CAM6460N5  马自达(MAZDA)        1435      2700       4555      1840   \n",
       "314     CAM6460D  马自达(MAZDA)        1560      2700       4555      1840   \n",
       "315    CAM6460D5  马自达(MAZDA)        1560      2700       4555      1840   \n",
       "316    CA6490AT5         马自达        1787      2950       4860      1852   \n",
       "317    CA6490AT5         马自达        1787      2950       4860      1852   \n",
       "318     CA6490AT         马自达        1762      2950       4860      1852   \n",
       "319    CA6490AT5         马自达        1787      2950       4860      1852   \n",
       "320    CA6490AT5         马自达        1787      2950       4860      1852   \n",
       "321     CA6490AT         马自达        1762      2950       4860      1852   \n",
       "322     CA6490AT         马自达        1762      2950       4860      1852   \n",
       "323     CA6490AT         马自达        1762      2950       4860      1852   \n",
       "324     CA6490AT         马自达        1762      2950       4860      1852   \n",
       "325  CA6473ATE4R         马自达        1806      2750       4705      1872   \n",
       "326   CA6473ATE5         马自达        1618      2750       4705      1872   \n",
       "327  CA6473ATE4R         马自达        1806      2750       4705      1872   \n",
       "328   CA6473ATE4         马自达        1618      2750       4705      1872   \n",
       "329  CA6473ATE4R         马自达        1806      2750       4705      1872   \n",
       "\n",
       "    car_height Displacement power                vin  car_factory    3 轴距[mm]  \\\n",
       "0         1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "1         1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "2         1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "3         1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "4         1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "5         1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "6         1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "7         1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "8         1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "9         1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "10        1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "11        1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "12        1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "13        1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "14        1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "15        1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "16        1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "17        1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "18        1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "19        1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "20        1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "21        1450         2488   141  LFPM5ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "22        1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "23        1450         1998   116  LFPM4ACP×××××××××   中国第一汽车集团公司  LFP   2830   \n",
       "24        1535         2488   141  LFPM5CPP×××××××××   中国第一汽车集团公司  LFP   2700   \n",
       "25        1535         2488   141  LFPM5CPP×××××××××   中国第一汽车集团公司  LFP   2700   \n",
       "26        1535         1998   116  LFPM4APE×××××××××   中国第一汽车集团公司  LFP   2700   \n",
       "27        1535         2488   141  LFPM5CPP×××××××××   中国第一汽车集团公司  LFP   2700   \n",
       "28        1535         1998   116  LFPM4APE×××××××××   中国第一汽车集团公司  LFP   2700   \n",
       "29        1535         2488   141  LFPM5CPP×××××××××   中国第一汽车集团公司  LFP   2700   \n",
       "..         ...          ...   ...                ...          ...  ...    ...   \n",
       "300       1710         1998   114  LVRHDCAC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "301       1710         1998   114  LVRHDCMC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "302       1710         2488   144  LVRHDCAS×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "303       1710         2488   144  LVRHDCAS×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "304       1710         1998   114  LVRHDCAC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "305       1710         1998   114  LVRHDCMC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "306       1710         1998   114  LVRHDCAC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "307       1710         1998   114  LVRHDCAC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "308       1710         2488   144  LVRHDCAS×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "309       1710         2488   144  LVRHDCAS×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "310       1710         1998   114  LVRHDCMC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "311       1710         1998   114  LVRHDCAC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "312       1710         1998   114  LVRHDCAC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "313       1710         1998   114  LVRHDCMC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "314       1710         1998   114  LVRHDCAC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "315       1710         1998   114  LVRHDCAC×××××××××  长安马自达汽车有限公司  LVR   2700   \n",
       "316       1685         2488   120  LFBME308×××××××××   中国第一汽车集团公司  LFB   2950   \n",
       "317       1685         2488   120  LFBME308×××××××××   中国第一汽车集团公司  LFB   2950   \n",
       "318       1685         2261   113  LFBME308×××××××××   中国第一汽车集团公司  LFB   2950   \n",
       "319       1685         2488   120  LFBME308×××××××××   中国第一汽车集团公司  LFB   2950   \n",
       "320       1685         2488   120  LFBME308×××××××××   中国第一汽车集团公司  LFB   2950   \n",
       "321       1685         2261   113  LFBME308×××××××××   中国第一汽车集团公司  LFB   2950   \n",
       "322       1685         2261   113  LFBME308×××××××××   中国第一汽车集团公司  LFB   2950   \n",
       "323       1685         2261   113  LFBME308×××××××××   中国第一汽车集团公司  LFB   2950   \n",
       "324       1685         2261   113  LFBME308×××××××××   中国第一汽车集团公司  LFB   2950   \n",
       "325       1645         2261   175  LFBME066×××××××××   中国第一汽车集团公司  LFB   2750   \n",
       "326       1645         2488   120  LFBME306×××××××××   中国第一汽车集团公司  LFB   2750   \n",
       "327       1645         2261   175  LFBME066×××××××××   中国第一汽车集团公司  LFB   2750   \n",
       "328       1645         2488   120  LFBME306×××××××××   中国第一汽车集团公司  LFB   2750   \n",
       "329       1645         2261   175  LFBME066×××××××××   中国第一汽车集团公司  LFB   2750   \n",
       "\n",
       "          长×宽×高[mm] brand_y    style  factory  \n",
       "0    4870x1840x1450     马自达      阿特兹       24  \n",
       "1    4870x1840x1450     马自达      阿特兹       24  \n",
       "2    4870x1840x1450     马自达      阿特兹       24  \n",
       "3    4870x1840x1450     马自达      阿特兹       24  \n",
       "4    4870x1840x1450     马自达      阿特兹       24  \n",
       "5    4870x1840x1450     马自达      阿特兹       24  \n",
       "6    4870x1840x1450     马自达      阿特兹       24  \n",
       "7    4870x1840x1450     马自达      阿特兹       24  \n",
       "8    4870x1840x1450     马自达      阿特兹       24  \n",
       "9    4870x1840x1450     马自达      阿特兹       24  \n",
       "10   4870x1840x1450     马自达      阿特兹       24  \n",
       "11   4870x1840x1450     马自达      阿特兹       24  \n",
       "12   4870x1840x1450     马自达      阿特兹       24  \n",
       "13   4870x1840x1450     马自达      阿特兹       24  \n",
       "14   4870x1840x1450     马自达      阿特兹       24  \n",
       "15   4870x1840x1450     马自达      阿特兹       24  \n",
       "16   4870x1840x1450     马自达      阿特兹       24  \n",
       "17   4870x1840x1450     马自达      阿特兹       24  \n",
       "18   4870x1840x1450     马自达      阿特兹       24  \n",
       "19   4870x1840x1450     马自达      阿特兹       24  \n",
       "20   4870x1840x1450     马自达      阿特兹       24  \n",
       "21   4870x1840x1450     马自达      阿特兹       24  \n",
       "22   4870x1840x1450     马自达      阿特兹       24  \n",
       "23   4870x1840x1450     马自达      阿特兹       24  \n",
       "24   4633x1840x1535     马自达  马自达CX-4        7  \n",
       "25   4633x1840x1535     马自达  马自达CX-4        7  \n",
       "26   4633x1840x1535     马自达  马自达CX-4        7  \n",
       "27   4633x1840x1535     马自达  马自达CX-4        7  \n",
       "28   4633x1840x1535     马自达  马自达CX-4        7  \n",
       "29   4633x1840x1535     马自达  马自达CX-4        7  \n",
       "..              ...     ...      ...      ...  \n",
       "300  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "301  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "302  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "303  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "304  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "305  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "306  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "307  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "308  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "309  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "310  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "311  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "312  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "313  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "314  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "315  4555x1840x1710     马自达  马自达CX-5       13  \n",
       "316  4860x1852x1685     马自达     马自达8       12  \n",
       "317  4860x1852x1685     马自达     马自达8       12  \n",
       "318  4860x1852x1685     马自达     马自达8       12  \n",
       "319  4860x1852x1685     马自达     马自达8       12  \n",
       "320  4860x1852x1685     马自达     马自达8       12  \n",
       "321  4860x1852x1685     马自达     马自达8       12  \n",
       "322  4860x1852x1685     马自达     马自达8       12  \n",
       "323  4860x1852x1685     马自达     马自达8       12  \n",
       "324  4860x1852x1685     马自达     马自达8       12  \n",
       "325  4705x1872x1645     马自达  马自达CX-7       10  \n",
       "326  4705x1872x1645     马自达  马自达CX-7       10  \n",
       "327  4705x1872x1645     马自达  马自达CX-7       10  \n",
       "328  4705x1872x1645     马自达  马自达CX-7       10  \n",
       "329  4705x1872x1645     马自达  马自达CX-7       10  \n",
       "\n",
       "[330 rows x 17 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('马自达_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
